class CreateClients < ActiveRecord::Migration
  def self.up
    create_table :clients do |t|
      t.string   :name, :surname, :city, :null => true, :default => nil, :limit => 50
      t.string   :society, :email, :webpage, :address, :null => true, :default => nil, :limit => 120
      t.string   :PI, :null => true, :default => nil, :limit => 20
      t.string   :name_responsible, :null => true, :default => nil, :limit => 100
      t.string   :tel_office, :tel_home, :tel_cell, :fax, :null => true, :default => nil, :limit => 15
      t.integer  :cap, :null => true, :default => nil, :limit => 11
      t.text     :notes
    
      t.datetime :created_at
    end
  end

  def self.down
    drop_table :clients
    remove_column :table_name, :column_name
  end
end